﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/
CREATE SEQUENCE dbo.OrderNumber
    AS int
    START WITH 1
    INCREMENT BY 1 ;
GO


INSERT INTO [OrderState] ([Id], [Description]) VALUES (1, 'FAILED Standing validation')
GO
INSERT INTO [OrderState] ([Id], [Description]) VALUES (10, 'Order received')
GO
INSERT INTO [OrderState] ([Id], [Description]) VALUES (15, 'Standing validated')
GO
INSERT INTO [OrderState] ([Id], [Description]) VALUES (20, 'Shipped')
GO
INSERT INTO [OrderState] ([Id], [Description]) VALUES (25, 'Invoiced')
GO
INSERT INTO [OrderState] ([Id], [Description]) VALUES (30, 'Payment recieved')
GO